﻿CREATE TABLE [dbo].[yaf_User]
(
[UserID] [int] NOT NULL IDENTITY(1, 1),
[BoardID] [int] NOT NULL,
[Name] [nvarchar] (50) COLLATE Cyrillic_General_BIN NOT NULL,
[Password] [nvarchar] (32) COLLATE Cyrillic_General_BIN NOT NULL,
[Email] [nvarchar] (50) COLLATE Cyrillic_General_BIN NULL,
[Joined] [datetime] NOT NULL,
[LastVisit] [datetime] NOT NULL,
[IP] [nvarchar] (15) COLLATE Cyrillic_General_BIN NULL,
[NumPosts] [int] NOT NULL,
[Location] [nvarchar] (50) COLLATE Cyrillic_General_BIN NULL,
[HomePage] [nvarchar] (50) COLLATE Cyrillic_General_BIN NULL,
[TimeZone] [int] NOT NULL,
[Avatar] [nvarchar] (255) COLLATE Cyrillic_General_BIN NULL,
[Signature] [ntext] COLLATE Cyrillic_General_BIN NULL,
[AvatarImage] [image] NULL,
[RankID] [int] NOT NULL,
[Suspended] [datetime] NULL,
[LanguageFile] [nvarchar] (50) COLLATE Cyrillic_General_BIN NULL,
[ThemeFile] [nvarchar] (50) COLLATE Cyrillic_General_BIN NULL,
[MSN] [nvarchar] (50) COLLATE Cyrillic_General_BIN NULL,
[YIM] [nvarchar] (30) COLLATE Cyrillic_General_BIN NULL,
[AIM] [nvarchar] (30) COLLATE Cyrillic_General_BIN NULL,
[ICQ] [int] NULL,
[RealName] [nvarchar] (50) COLLATE Cyrillic_General_BIN NULL,
[Occupation] [nvarchar] (50) COLLATE Cyrillic_General_BIN NULL,
[Interests] [nvarchar] (100) COLLATE Cyrillic_General_BIN NULL,
[Gender] [tinyint] NOT NULL,
[Weblog] [nvarchar] (100) COLLATE Cyrillic_General_BIN NULL,
[PMNotification] [bit] NOT NULL,
[Flags] [int] NOT NULL,
[Points] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


